<?php

class LtDbConnectionAdapterMysql implements LtDbConnectionAdapter
{
    public function connect($connConf)
    {
        return mysql_connect($connConf["host"] . ":" . $connConf["port"], $connConf["username"], $connConf["password"]);
    }

    public function exec($sql, $connResource)
    {
        return mysql_query($sql, $connResource) ? mysql_affected_rows($connResource) : false;
    }

    public function query($sql, $connResource)
    {
        $result = mysql_query($sql, $connResource);
        $rows = array();
        while ($row = mysql_fetch_assoc($result)) {
            $rows[] = $row;
        }
        return $rows;
    }

    public function lastInsertId($connResource)
    {
        return mysql_insert_id($connResource);
    }

    public function escape($sql, $connResource)
    {
        return mysql_real_escape_string($sql, $connResource);
    }
}